object frmReturns: TfrmReturns
  Left = 0
  Top = 0
  Caption = 'Returns'
  ClientHeight = 457
  ClientWidth = 879
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object pnlMain: TPanel
    Left = 0
    Top = 33
    Width = 879
    Height = 424
    Align = alClient
    TabOrder = 0
    object pnlMainInfo: TPanel
      Left = 1
      Top = 1
      Width = 877
      Height = 57
      Align = alTop
      TabOrder = 0
      DesignSize = (
        877
        57)
      object lbl1: TLabel
        Left = 2
        Top = 9
        Width = 33
        Height = 13
        AutoSize = False
        Caption = 'RE NO'
      end
      object lbl2: TLabel
        Left = 168
        Top = 9
        Width = 57
        Height = 13
        AutoSize = False
        Caption = #36864#36135#26085#26399
      end
      object lbl5: TLabel
        Left = 2
        Top = 34
        Width = 65
        Height = 13
        AutoSize = False
        Caption = #36864#36135#24635#25968#37327
      end
      object lbl3: TLabel
        Left = 326
        Top = 8
        Width = 24
        Height = 13
        Caption = #21407#22240
      end
      object edtRENO: TEdit
        Left = 65
        Top = 5
        Width = 97
        Height = 21
        Color = clMoneyGreen
        ReadOnly = True
        TabOrder = 0
      end
      object dtpParchaseDate: TDateTimePicker
        Left = 225
        Top = 5
        Width = 89
        Height = 21
        Date = 39790.000000000000000000
        Time = 39790.000000000000000000
        Enabled = False
        TabOrder = 1
      end
      object edtAllQty: TEdit
        Left = 65
        Top = 30
        Width = 97
        Height = 21
        Color = clMoneyGreen
        ReadOnly = True
        TabOrder = 2
      end
      object mmo1: TMemo
        Left = 356
        Top = 5
        Width = 510
        Height = 46
        Anchors = [akLeft, akTop, akRight]
        TabOrder = 3
      end
    end
    object pnlDetailOperate: TPanel
      Left = 1
      Top = 58
      Width = 877
      Height = 31
      Align = alTop
      TabOrder = 1
      DesignSize = (
        877
        31)
      object lbl12: TLabel
        Left = 8
        Top = 11
        Width = 89
        Height = 13
        AutoSize = False
        Caption = #36864#36135#26126#32454
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'MS Sans Serif'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object lblcode: TLabel
        Left = 103
        Top = 6
        Width = 27
        Height = 13
        Caption = 'code'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Tahoma'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object btnDetailDelete: TButton
        Left = 710
        Top = 3
        Width = 75
        Height = 25
        Anchors = [akTop, akRight]
        Caption = #21024#38500#35760#24405
        TabOrder = 0
        OnClick = btnDetailDeleteClick
      end
      object btnsave: TButton
        Left = 791
        Top = 3
        Width = 75
        Height = 25
        Anchors = [akTop, akRight]
        Caption = #20445#23384
        TabOrder = 1
        OnClick = btnsaveClick
      end
      object edtCode: TRzEdit
        Left = 136
        Top = 4
        Width = 169
        Height = 21
        TabOrder = 2
        OnClick = edtCodeClick
        OnKeyPress = edtCodeKeyPress
      end
      object btnQtydown: TButton
        Left = 629
        Top = 3
        Width = 75
        Height = 25
        Anchors = [akTop, akRight]
        Caption = #25968#37327'-1'
        TabOrder = 3
        OnClick = btnQtydownClick
      end
    end
    object dbgdStoreGoods: TDBGridEh
      Left = 1
      Top = 89
      Width = 877
      Height = 334
      Align = alClient
      DataGrouping.GroupLevels = <>
      DataSource = dsReturnsDT
      Flat = False
      FooterColor = clWindow
      FooterFont.Charset = DEFAULT_CHARSET
      FooterFont.Color = clWindowText
      FooterFont.Height = -11
      FooterFont.Name = 'Tahoma'
      FooterFont.Style = []
      FooterRowCount = 1
      IndicatorOptions = [gioShowRowIndicatorEh]
      ReadOnly = True
      SumList.Active = True
      TabOrder = 2
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'Tahoma'
      TitleFont.Style = []
      Columns = <
        item
          EditButtons = <>
          FieldName = 'style'
          Footer.Alignment = taRightJustify
          Footer.Value = 'Record'
          Footer.ValueType = fvtStaticText
          Footers = <>
          Width = 183
        end
        item
          EditButtons = <>
          FieldName = 'barcode'
          Footer.Alignment = taRightJustify
          Footer.FieldName = 'barcode'
          Footer.ValueType = fvtCount
          Footers = <>
          Width = 83
        end
        item
          EditButtons = <>
          FieldName = 'code'
          Footers = <>
          Width = 193
        end
        item
          EditButtons = <>
          FieldName = 'Description'
          Footer.Alignment = taRightJustify
          Footer.Value = 'All Qty'
          Footer.ValueType = fvtStaticText
          Footers = <>
          Width = 309
        end
        item
          EditButtons = <>
          FieldName = 'qty'
          Footer.FieldName = 'qty'
          Footer.ValueType = fvtSum
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'size'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'brand'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'color'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'otherCode'
          Footers = <>
          Width = 178
        end
        item
          EditButtons = <>
          FieldName = 'name'
          Footers = <>
        end>
      object RowDetailData: TRowDetailPanelControlEh
      end
    end
  end
  object pnlTitle: TPanel
    Left = 0
    Top = 0
    Width = 879
    Height = 33
    Align = alTop
    Caption = #36864#36135
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 1
  end
  object myqryReturnsDt: TMyQuery
    Connection = DMMySQL.conMySQL
    SQL.Strings = (
      'select dt.id,dt.goodsID,dt.qty,'
      
        'sg.barcode,sg.code,sg.name,sg.brand,sg.size,sg.style,sg.color,sg' +
        '.otherCode,sg.Description '
      ' from returnsdt dt left join goodsinfo sg on dt.goodsID= sg.id'
      'where 1=0;')
    ReadOnly = True
    Left = 376
    Top = 240
  end
  object dsPrdReturnsDT: TDataSetProvider
    DataSet = myqryReturnsDt
    BeforeUpdateRecord = dsPrdReturnsDTBeforeUpdateRecord
    Left = 432
    Top = 240
  end
  object cdsReturnsDT: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsPrdReturnsDT'
    Left = 496
    Top = 240
    object cdsReturnsDTid: TLargeintField
      FieldName = 'id'
      Origin = 'dt.id'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
    end
    object cdsReturnsDTgoodsID: TLargeintField
      FieldName = 'goodsID'
      Origin = 'dt.goodsID'
    end
    object cdsReturnsDTqty: TIntegerField
      FieldName = 'qty'
      Origin = 'dt.qty'
    end
    object cdsReturnsDTbarcode: TWideStringField
      FieldName = 'barcode'
      Origin = 'sg.barcode'
    end
    object cdsReturnsDTcode: TWideStringField
      FieldName = 'code'
      Origin = 'sg.code'
      Size = 50
    end
    object cdsReturnsDTname: TWideStringField
      FieldName = 'name'
      Origin = 'sg.name'
      Size = 50
    end
    object cdsReturnsDTbrand: TWideStringField
      FieldName = 'brand'
      Origin = 'sg.brand'
    end
    object cdsReturnsDTsize: TWideStringField
      FieldName = 'size'
      Origin = 'sg.size'
      Size = 10
    end
    object cdsReturnsDTstyle: TWideStringField
      FieldName = 'style'
      Origin = 'sg.style'
    end
    object cdsReturnsDTcolor: TWideStringField
      FieldName = 'color'
      Size = 10
    end
    object cdsReturnsDTotherCode: TWideStringField
      FieldName = 'otherCode'
      Size = 100
    end
    object cdsReturnsDTDescription: TWideStringField
      FieldName = 'Description'
      Size = 255
    end
  end
  object dsReturnsDT: TDataSource
    DataSet = cdsReturnsDT
    Left = 560
    Top = 240
  end
  object myqryGoodsInfo: TMyQuery
    Connection = DMMySQL.conMySQL
    SQL.Strings = (
      'select * from GoodsInfo where barcode=:barcode or `code`=:code;')
    Left = 632
    Top = 200
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'barcode'
      end
      item
        DataType = ftUnknown
        Name = 'code'
      end>
  end
end
